UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoQqWK5Fz9JacrOZVAV+Tgg5jWhsIDPIq3Z/gXLtelo='
WHERE
key_id = 'b7ea0dd37944cdc27c80b43ef8ec460d440f1034266c588124b4de6fca94e1f2'
AND (
token = 'RoQqWK5Fz9JacrOZVAV+Tgg5jWhsIDPIq3Z/gXLtelo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)