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