UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eecrw9uZzl6XVRZtPnFiyCOdQOxafL2XsPxCpbPd/qQ=' 
WHERE 
  key_id = '9c962225a86ca11a1894c630d0eda61a8d973f8d1a89ac53e4442b5662cbf495' 
  AND (
    token = 'eecrw9uZzl6XVRZtPnFiyCOdQOxafL2XsPxCpbPd/qQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024