UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kliJpZXhhYL1j+5pCKozGsLjcy17nPnYjYQHmlrnnqU='
WHERE
key_id = '58bedbdb233e552dc850e066381f8c2aa66efcc09f74ef5a9e4b9c5ce5c6b3c9'
AND (
token = 'kliJpZXhhYL1j+5pCKozGsLjcy17nPnYjYQHmlrnnqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)