UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnZXkDD8BQEhnK+4D168glu+NLrSeMRDbxDk/pv3KnM='
WHERE
key_id = '1f4c67bd85447f61dcbdffef441b608b4c30de7512d0ef2318dc6a54e514f247'
AND (
token = 'KnZXkDD8BQEhnK+4D168glu+NLrSeMRDbxDk/pv3KnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)