UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pmZDfK2WL2GDex24MJ7J5vaC/rRbs8y+mSs8uCskLlE=' 
WHERE 
  key_id = '506f1b1bee75218c06e7f22051afd57f6fb94609265f0d01e73d8298b7083b8b' 
  AND (
    token = 'pmZDfK2WL2GDex24MJ7J5vaC/rRbs8y+mSs8uCskLlE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025