UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZlWj78h0piJTiXx4rCd1S8HIxFbIzWkEgBbY0uaWVk='
WHERE
key_id = 'd91a9cc560bdddb2d4bedd902948b4bf6ff08b82ca314ddc83f474b101ca23f4'
AND (
token = 'xZlWj78h0piJTiXx4rCd1S8HIxFbIzWkEgBbY0uaWVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)