UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RTHcxgML2JhUKCX1n+dLnQ10o/PE42uiU7Uz1/olKD0='
WHERE
key_id = '7a6cf4a2840298253ae170d28a27988bf61e94837b561bebc03b86c92a0f1bee'
AND (
token = 'RTHcxgML2JhUKCX1n+dLnQ10o/PE42uiU7Uz1/olKD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)