UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXq7otnndSvoYsDwF7OzK9SjWnzjSUXLQ2CATvZ0Ji8='
WHERE
key_id = '426871f397fa11203a950856104b8a4d027ef8d5a6b47709ccf127479a566ad7'
AND (
token = 'kXq7otnndSvoYsDwF7OzK9SjWnzjSUXLQ2CATvZ0Ji8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)