UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNbVjKY2hUJ+kVeyXXxdoQyQzIzysm/mrLMa8MStJpE='
WHERE
key_id = 'fcf05cd1f96b734436344a5dcff92b8b2177e527bff5681cdd8058fb26ae1b09'
AND (
token = 'HNbVjKY2hUJ+kVeyXXxdoQyQzIzysm/mrLMa8MStJpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)