UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LkBUbTTiKfSJK5/LxUVEsXbjnI5bRUvwSw92h3lF/wo=' 
WHERE 
  key_id = '49bc8a6cae88f68aad2bc8e88a95e1122e24e440c3bc514d1f0d05e9f36cceb7' 
  AND (
    token = 'LkBUbTTiKfSJK5/LxUVEsXbjnI5bRUvwSw92h3lF/wo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021