UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2Z2pito97y3So70hHDOFN2elKJtmUwUYNGrdQrpXCdM=' 
WHERE 
  key_id = 'de2b3c9147f369cb0a1f287d2f23dacc6362d0ad61b4004b7bb7e2956ffa1dad' 
  AND (
    token = '2Z2pito97y3So70hHDOFN2elKJtmUwUYNGrdQrpXCdM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044