UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YEX96oXRpHJo4Es2QSLrr+RV3SFGX3or+rr1gUvnfFs=' 
WHERE 
  key_id = '9bb0cfd628775804028210dbd9603bc5b9c0606be9654b2b7fac26aec74d4070' 
  AND (
    token = 'YEX96oXRpHJo4Es2QSLrr+RV3SFGX3or+rr1gUvnfFs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029