UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eO1bkW1QcRACx5XAnX/0/9M93jXqz5ZBkJlg7it6QC0='
WHERE
key_id = 'fd29b755641979ab9b8aef5b4e00268f4c27766a4f30da3f399a132e99cee380'
AND (
token = 'eO1bkW1QcRACx5XAnX/0/9M93jXqz5ZBkJlg7it6QC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)