UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fEOeoX27HydV5p8e/1wAKjLDNvZW3vIQggjb6MoRiuc='
WHERE
key_id = 'ad9c4bc07a34e87e9578788375a5b5aacca646e57b6d3c2233c8b6970f9b26dd'
AND (
token = 'fEOeoX27HydV5p8e/1wAKjLDNvZW3vIQggjb6MoRiuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)