UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pv96+m8nc3nSQXu2aWyvaIbGTxM4Oj8BSoASyJhWew='
WHERE
key_id = '8c13bd6cf55f27446e7c8f2f3d0f8f8d1100997aaa4f14ad92d82dd45b79052c'
AND (
token = '1pv96+m8nc3nSQXu2aWyvaIbGTxM4Oj8BSoASyJhWew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)