UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ePA6J/czagX90EVux9ufPMcF2mMYXPi30zD57y/qlAE=' 
WHERE 
  key_id = '5cec89a0402e56fe365fad3462f49ea49c9983eca06759c9ca3da92ec53bf26b' 
  AND (
    token = 'ePA6J/czagX90EVux9ufPMcF2mMYXPi30zD57y/qlAE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040