UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sp+K2gtqOQ3OthjGapP21PFkaL/n1sX7eh8hSN9zxg='
WHERE
key_id = 'a15e5f38d548188e5be6e995d5b42fdce712e1d40edc8dea56e3e8435c5d9477'
AND (
token = '0sp+K2gtqOQ3OthjGapP21PFkaL/n1sX7eh8hSN9zxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)