UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZjhGPmdTOrdRNwHERdNbIoQ11uPsi0gC0Wv+I+t+00='
WHERE
key_id = 'df5295d337e3fa8c1a921990562844f77dd6bf989f71de967a7ae2fe8ae8ff27'
AND (
token = 'hZjhGPmdTOrdRNwHERdNbIoQ11uPsi0gC0Wv+I+t+00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)