UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yTd0wAhbUcCSwjIpO1qZ0jLtu2r9THpS7dhcr7HgCbY='
WHERE
key_id = '304c3340a2c4db3ebfec76d6653794d3a9054f985622c3c8eb9e718cfb04ff68'
AND (
token = 'yTd0wAhbUcCSwjIpO1qZ0jLtu2r9THpS7dhcr7HgCbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)