UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'a+Xns6UDRiVod+KPiggQsE3Xt6Q7GHlFbDn7bgyQO6U=' 
WHERE 
  key_id = 'fdf8c1a8a69b9e84a09f7931aa1d295135e1e83268d9a833b6e9497ef4e49af7' 
  AND (
    token = 'a+Xns6UDRiVod+KPiggQsE3Xt6Q7GHlFbDn7bgyQO6U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035