UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lpgzMAjpumeQblOiCCl6U6mwTEa/5nNsYrd60qVS70s='
WHERE
key_id = '3a14f6b36c9dbba67d3b25dbae8ae55a19dfdfd528e723ea13267d76550e24e0'
AND (
token = 'lpgzMAjpumeQblOiCCl6U6mwTEa/5nNsYrd60qVS70s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)