UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ZVzXh+Zuke3ZB3Kedh0n3zby4XxjcNiMUtsk8H2HZ4='
WHERE
key_id = 'a786b9a4fd467064b262b9b17a349ae0eedb9397b03103c0464caa7e355c03e1'
AND (
token = '+ZVzXh+Zuke3ZB3Kedh0n3zby4XxjcNiMUtsk8H2HZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)