UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'logZ7iI92C6M8VJF3ANF8ESmOaBURG98WnZ9JW8ODjA='
WHERE
key_id = 'd6471e59f08ec245d110fa10d744496539e94f432908e02934b9b4ffcbdcf6e5'
AND (
token = 'logZ7iI92C6M8VJF3ANF8ESmOaBURG98WnZ9JW8ODjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)