UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1HShZyQP1qPJjNHtmqaZLn1e3LNQUsMCOZazga16Dh8='
WHERE
key_id = 'f32a3d01c917844da56cace808707ccccb00abe44f65a67d05ccf52689406659'
AND (
token = '1HShZyQP1qPJjNHtmqaZLn1e3LNQUsMCOZazga16Dh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)