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