UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBm5gk48N1wPeOy/IjbDDRJnAAWdxuovrhmGUtq/t78='
WHERE
key_id = 'f8f6f5a80d3d82901e34f52f33711ab2251acf90d533737c648c9286d255a2db'
AND (
token = 'ZBm5gk48N1wPeOy/IjbDDRJnAAWdxuovrhmGUtq/t78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)