UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK6yaW4AwA8jen/OKshRHdQlw3I8nUam9RtF20SerS4='
WHERE
key_id = '60471aa398b9812d59017bb291870815c5c0a5394bf775ebd6ab45fa9d3ad450'
AND (
token = 'zK6yaW4AwA8jen/OKshRHdQlw3I8nUam9RtF20SerS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)