UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5+EQ5GIa5vUP0rIjq5bStaqK46a6MYySZeECPBZtj0='
WHERE
key_id = 'e29a9f18010b21233d9505a5cca9df182b44cb4985f0caa698a4bef6d42313d4'
AND (
token = 'X5+EQ5GIa5vUP0rIjq5bStaqK46a6MYySZeECPBZtj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)