UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8cYdP0SLRNcoOadeFIC7QXtKYQGrCaD1cn3MNF2wZps='
WHERE
key_id = 'ce54d1884fc7e25936022dc6ca3ff97beea576ba85740b19b5b3dfeaa043fbd3'
AND (
token = '8cYdP0SLRNcoOadeFIC7QXtKYQGrCaD1cn3MNF2wZps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)