UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4RZG5NWdhQ7yXyLhw4XCuzWKsQB9qAUobKkqvJ5XFkU='
WHERE
key_id = 'c67d01afb5424cb03dd1f550c3754fed38c300d32d61133696b1eafc9168c048'
AND (
token = '4RZG5NWdhQ7yXyLhw4XCuzWKsQB9qAUobKkqvJ5XFkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)