UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'G47uMhF03aop0lkfe7h7WJ5EiAVeC1OEPMAl/c1uDlc=' 
WHERE 
  key_id = '5b274cdbbc5b573b5d5396e941afd89f1dbde0ac0c1c699208f97afda0ba0f10' 
  AND (
    token = 'G47uMhF03aop0lkfe7h7WJ5EiAVeC1OEPMAl/c1uDlc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023