UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cJm/6nK1bMLP35AnJ+5ajf7mAW/GP15xU9kL+DRGSHU=' 
WHERE 
  key_id = '6908db7ef079247f67ad8e6c6b931568486716f0090a0301ca8525c1c4383b56' 
  AND (
    token = 'cJm/6nK1bMLP35AnJ+5ajf7mAW/GP15xU9kL+DRGSHU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00068