UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QeKgvTZ+kNAADrTqziZ2J2gpm9jaJF5uYoC/p1h4gCA=' 
WHERE 
  key_id = '423c3cbcb281bdc5f51a497fdb6cf615f0823b2547ab5f4172ddccf28175fc40' 
  AND (
    token = 'QeKgvTZ+kNAADrTqziZ2J2gpm9jaJF5uYoC/p1h4gCA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023