UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'z/KiSxspckyHoewnjJ9350J8X4Frv3G5KP6Jz+v9XyY=' 
WHERE 
  key_id = '2dc76034d5bc5d8422d0d7a858a79306b5cb37a9350a73e58772e6ae8b165908' 
  AND (
    token = 'z/KiSxspckyHoewnjJ9350J8X4Frv3G5KP6Jz+v9XyY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034