UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1/j68E8YmG4laMDxlx3Svuj/h6sG8awdoIfZs/9qbA8='
WHERE
key_id = '8dfcf19dd87e588310cc13bc086c77848659a4af9272c50dab1555d461150b98'
AND (
token = '1/j68E8YmG4laMDxlx3Svuj/h6sG8awdoIfZs/9qbA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)