UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CC4jMSMjxYhynTMd4tiM9OPOhs6oIrBr37MZnABi2uE='
WHERE
key_id = 'abc598725ef2f8a06ea980878b6608c6ce4e4e319585c0e275ea70fe1f17aea4'
AND (
token = 'CC4jMSMjxYhynTMd4tiM9OPOhs6oIrBr37MZnABi2uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)