UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RhH+h8TFVEtRdYIK0vbffrVICxF0E9Fa2Am4lkGkNYI='
WHERE
key_id = 'fed85681c5c88c3ce272c61f12dae998adca99c45c3b6382edef3cda7364f29f'
AND (
token = 'RhH+h8TFVEtRdYIK0vbffrVICxF0E9Fa2Am4lkGkNYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)