UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aN9U/kDK1zxVDiCI4sbkIS5qfIi5uXyRBNNblvkBwgY='
WHERE
key_id = 'ad4fbb5d459408bc1a4086edc66dd59f565768672981674e1d3f09b2e4dc5fbd'
AND (
token = 'aN9U/kDK1zxVDiCI4sbkIS5qfIi5uXyRBNNblvkBwgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)