UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrOjgOLL5DeaM6KScrJlwqBOakC++oh4CiL7mslv1wY='
WHERE
key_id = 'ca17274729c63171e401b5ec4a80517bbe979f912431b8d2973db1e090da6e14'
AND (
token = 'IrOjgOLL5DeaM6KScrJlwqBOakC++oh4CiL7mslv1wY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)