UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OfroQ6Aob616x1dN9l0H1m1Gr0YDJ8EDl3sgswGoUok='
WHERE
key_id = '7f9f1672d10fcc5c33b65639a0bb827a05a1f3008c72246c9b980179471a6a36'
AND (
token = 'OfroQ6Aob616x1dN9l0H1m1Gr0YDJ8EDl3sgswGoUok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)