UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6SJ8CgNRQFl1lXb3J2azit6SCejgQzjSEGN9tNnBbRs='
WHERE
key_id = 'a675b2a651b53d2042558b63e576b692ef2c3ebc8dc2af88c8858f8a9e97bf20'
AND (
token = '6SJ8CgNRQFl1lXb3J2azit6SCejgQzjSEGN9tNnBbRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)